INSERT INTO `mw_zone` (`zone_id`, `country_id`, `name`, `code`, `status`, `date_added`, `last_updated`) VALUES
(2345, 153, 'Bay of Plenty', 'BOP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2346, 153, 'Canterbury', 'CAN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2347, 153, 'Coromandel', 'COR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2348, 153, 'Gisborne', 'GIS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2349, 153, 'Fiordland', 'FIO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2350, 153, 'Hawke''s Bay', 'HKB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2351, 153, 'Marlborough', 'MBH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2352, 153, 'Manawatu-Wanganui', 'MWT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2353, 153, 'Mt Cook-Mackenzie', 'MCM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2354, 153, 'Nelson', 'NSN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2355, 153, 'Northland', 'NTL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2356, 153, 'Otago', 'OTA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2357, 153, 'Southland', 'STL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2358, 153, 'Taranaki', 'TKI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2359, 153, 'Wellington', 'WGN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2360, 153, 'Waikato', 'WKO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2361, 153, 'Wairprarapa', 'WAI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2362, 153, 'West Coast', 'WTC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2363, 154, 'Atlantico Norte', 'AN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2364, 154, 'Atlantico Sur', 'AS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2365, 154, 'Boaco', 'BO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2366, 154, 'Carazo', 'CA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2367, 154, 'Chinandega', 'CI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2368, 154, 'Chontales', 'CO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2369, 154, 'Esteli', 'ES', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2370, 154, 'Granada', 'GR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2371, 154, 'Jinotega', 'JI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2372, 154, 'Leon', 'LE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2373, 154, 'Madriz', 'MD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2374, 154, 'Managua', 'MN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2375, 154, 'Masaya', 'MS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2376, 154, 'Matagalpa', 'MT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2377, 154, 'Nuevo Segovia', 'NS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2378, 154, 'Rio San Juan', 'RS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2379, 154, 'Rivas', 'RI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2380, 155, 'Agadez', 'AG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2381, 155, 'Diffa', 'DF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2382, 155, 'Dosso', 'DS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2383, 155, 'Maradi', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2384, 155, 'Niamey', 'NM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2385, 155, 'Tahoua', 'TH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2386, 155, 'Tillaberi', 'TL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2387, 155, 'Zinder', 'ZD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2388, 156, 'Abia', 'AB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2389, 156, 'Abuja Federal Capital Territory', 'CT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2390, 156, 'Adamawa', 'AD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2391, 156, 'Akwa Ibom', 'AK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2392, 156, 'Anambra', 'AN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2393, 156, 'Bauchi', 'BC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2394, 156, 'Bayelsa', 'BY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2395, 156, 'Benue', 'BN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2396, 156, 'Borno', 'BO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2397, 156, 'Cross River', 'CR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2398, 156, 'Delta', 'DE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2399, 156, 'Ebonyi', 'EB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2400, 156, 'Edo', 'ED', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2401, 156, 'Ekiti', 'EK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2402, 156, 'Enugu', 'EN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2403, 156, 'Gombe', 'GO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2404, 156, 'Imo', 'IM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2405, 156, 'Jigawa', 'JI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2406, 156, 'Kaduna', 'KD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2407, 156, 'Kano', 'KN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2408, 156, 'Katsina', 'KT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2409, 156, 'Kebbi', 'KE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2410, 156, 'Kogi', 'KO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2411, 156, 'Kwara', 'KW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2412, 156, 'Lagos', 'LA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2413, 156, 'Nassarawa', 'NA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2414, 156, 'Niger', 'NI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2415, 156, 'Ogun', 'OG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2416, 156, 'Ondo', 'ONG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2417, 156, 'Osun', 'OS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2418, 156, 'Oyo', 'OY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2419, 156, 'Plateau', 'PL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2420, 156, 'Rivers', 'RI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2421, 156, 'Sokoto', 'SO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2422, 156, 'Taraba', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2423, 156, 'Yobe', 'YO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2424, 156, 'Zamfara', 'ZA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2425, 159, 'Northern Islands', 'N', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2426, 159, 'Rota', 'R', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2427, 159, 'Saipan', 'S', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2428, 159, 'Tinian', 'T', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2429, 160, 'Akershus', 'AK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2430, 160, 'Aust-Agder', 'AA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2431, 160, 'Buskerud', 'BU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2432, 160, 'Finnmark', 'FM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2433, 160, 'Hedmark', 'HM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2434, 160, 'Hordaland', 'HL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2435, 160, 'More og Romdal', 'MR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2436, 160, 'Nord-Trondelag', 'NT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2437, 160, 'Nordland', 'NL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2438, 160, 'Ostfold', 'OF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2439, 160, 'Oppland', 'OP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2440, 160, 'Oslo', 'OL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2441, 160, 'Rogaland', 'RL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2442, 160, 'Sor-Trondelag', 'ST', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2443, 160, 'Sogn og Fjordane', 'SJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2444, 160, 'Svalbard', 'SV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2445, 160, 'Telemark', 'TM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2446, 160, 'Troms', 'TR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2447, 160, 'Vest-Agder', 'VA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2448, 160, 'Vestfold', 'VF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2449, 161, 'Ad Dakhiliyah', 'DA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2450, 161, 'Al Batinah', 'BA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2451, 161, 'Al Wusta', 'WU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2452, 161, 'Ash Sharqiyah', 'SH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2453, 161, 'Az Zahirah', 'ZA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2454, 161, 'Masqat', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2455, 161, 'Musandam', 'MU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2456, 161, 'Zufar', 'ZU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2457, 162, 'Balochistan', 'B', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2458, 162, 'Federally Administered Tribal Areas', 'T', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2459, 162, 'Islamabad Capital Territory', 'I', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2460, 162, 'North-West Frontier', 'N', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2461, 162, 'Punjab', 'P', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2462, 162, 'Sindh', 'S', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2463, 163, 'Aimeliik', 'AM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2464, 163, 'Airai', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2465, 163, 'Angaur', 'AN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2466, 163, 'Hatohobei', 'HA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2467, 163, 'Kayangel', 'KA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2468, 163, 'Koror', 'KO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2469, 163, 'Melekeok', 'ME', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2470, 163, 'Ngaraard', 'NA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2471, 163, 'Ngarchelong', 'NG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2472, 163, 'Ngardmau', 'ND', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2473, 163, 'Ngatpang', 'NT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2474, 163, 'Ngchesar', 'NC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2475, 163, 'Ngeremlengui', 'NR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2476, 163, 'Ngiwal', 'NW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2477, 163, 'Peleliu', 'PE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2478, 163, 'Sonsorol', 'SO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2479, 164, 'Bocas del Toro', 'BT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2480, 164, 'Chiriqui', 'CH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2481, 164, 'Cocle', 'CC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2482, 164, 'Colon', 'CL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2483, 164, 'Darien', 'DA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2484, 164, 'Herrera', 'HE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2485, 164, 'Los Santos', 'LS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2486, 164, 'Panama', 'PA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2487, 164, 'San Blas', 'SB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2488, 164, 'Veraguas', 'VG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2489, 165, 'Bougainville', 'BV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2490, 165, 'Central', 'CE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2491, 165, 'Chimbu', 'CH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2492, 165, 'Eastern Highlands', 'EH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2493, 165, 'East New Britain', 'EB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2494, 165, 'East Sepik', 'ES', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2495, 165, 'Enga', 'EN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2496, 165, 'Gulf', 'GU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2497, 165, 'Madang', 'MD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2498, 165, 'Manus', 'MN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2499, 165, 'Milne Bay', 'MB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2500, 165, 'Morobe', 'MR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2501, 165, 'National Capital', 'NC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2502, 165, 'New Ireland', 'NI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2503, 165, 'Northern', 'NO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2504, 165, 'Sandaun', 'SA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2505, 165, 'Southern Highlands', 'SH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2506, 165, 'Western', 'WE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2507, 165, 'Western Highlands', 'WH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2508, 165, 'West New Britain', 'WB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2509, 166, 'Alto Paraguay', 'AG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2510, 166, 'Alto Parana', 'AN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2511, 166, 'Amambay', 'AM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2512, 166, 'Asuncion', 'AS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2513, 166, 'Boqueron', 'BO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2514, 166, 'Caaguazu', 'CG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2515, 166, 'Caazapa', 'CZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2516, 166, 'Canindeyu', 'CN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2517, 166, 'Central', 'CE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2518, 166, 'Concepcion', 'CC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2519, 166, 'Cordillera', 'CD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2520, 166, 'Guaira', 'GU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2521, 166, 'Itapua', 'IT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2522, 166, 'Misiones', 'MI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2523, 166, 'Neembucu', 'NE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2524, 166, 'Paraguari', 'PA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2525, 166, 'Presidente Hayes', 'PH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2526, 166, 'San Pedro', 'SP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2527, 167, 'Amazonas', 'AM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2528, 167, 'Ancash', 'AN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2529, 167, 'Apurimac', 'AP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2530, 167, 'Arequipa', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2531, 167, 'Ayacucho', 'AY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2532, 167, 'Cajamarca', 'CJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2533, 167, 'Callao', 'CL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2534, 167, 'Cusco', 'CU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2535, 167, 'Huancavelica', 'HV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2536, 167, 'Huanuco', 'HO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2537, 167, 'Ica', 'IC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2538, 167, 'Junin', 'JU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2539, 167, 'La Libertad', 'LD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2540, 167, 'Lambayeque', 'LY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2541, 167, 'Lima', 'LI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2542, 167, 'Loreto', 'LO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2543, 167, 'Madre de Dios', 'MD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2544, 167, 'Moquegua', 'MO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2545, 167, 'Pasco', 'PA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2546, 167, 'Piura', 'PI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2547, 167, 'Puno', 'PU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2548, 167, 'San Martin', 'SM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2549, 167, 'Tacna', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2550, 167, 'Tumbes', 'TU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2551, 167, 'Ucayali', 'UC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2552, 168, 'Abra', 'ABR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2553, 168, 'Agusan del Norte', 'ANO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2554, 168, 'Agusan del Sur', 'ASU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2555, 168, 'Aklan', 'AKL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2556, 168, 'Albay', 'ALB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2557, 168, 'Antique', 'ANT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2558, 168, 'Apayao', 'APY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2559, 168, 'Aurora', 'AUR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2560, 168, 'Basilan', 'BAS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2561, 168, 'Bataan', 'BTA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2562, 168, 'Batanes', 'BTE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2563, 168, 'Batangas', 'BTG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2564, 168, 'Biliran', 'BLR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2565, 168, 'Benguet', 'BEN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2566, 168, 'Bohol', 'BOL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2567, 168, 'Bukidnon', 'BUK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2568, 168, 'Bulacan', 'BUL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2569, 168, 'Cagayan', 'CAG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2570, 168, 'Camarines Norte', 'CNO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2571, 168, 'Camarines Sur', 'CSU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2572, 168, 'Camiguin', 'CAM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2573, 168, 'Capiz', 'CAP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2574, 168, 'Catanduanes', 'CAT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2575, 168, 'Cavite', 'CAV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2576, 168, 'Cebu', 'CEB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2577, 168, 'Compostela', 'CMP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2578, 168, 'Davao del Norte', 'DNO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2579, 168, 'Davao del Sur', 'DSU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2580, 168, 'Davao Oriental', 'DOR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2581, 168, 'Eastern Samar', 'ESA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2582, 168, 'Guimaras', 'GUI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2583, 168, 'Ifugao', 'IFU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2584, 168, 'Ilocos Norte', 'INO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2585, 168, 'Ilocos Sur', 'ISU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2586, 168, 'Iloilo', 'ILO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2587, 168, 'Isabela', 'ISA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2588, 168, 'Kalinga', 'KAL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2589, 168, 'Laguna', 'LAG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2590, 168, 'Lanao del Norte', 'LNO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2591, 168, 'Lanao del Sur', 'LSU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2592, 168, 'La Union', 'UNI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2593, 168, 'Leyte', 'LEY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2594, 168, 'Maguindanao', 'MAG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2595, 168, 'Marinduque', 'MRN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2596, 168, 'Masbate', 'MSB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2597, 168, 'Mindoro Occidental', 'MIC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2598, 168, 'Mindoro Oriental', 'MIR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2599, 168, 'Misamis Occidental', 'MSC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2600, 168, 'Misamis Oriental', 'MOR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2601, 168, 'Mountain', 'MOP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2602, 168, 'Negros Occidental', 'NOC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2603, 168, 'Negros Oriental', 'NOR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2604, 168, 'North Cotabato', 'NCT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2605, 168, 'Northern Samar', 'NSM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2606, 168, 'Nueva Ecija', 'NEC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2607, 168, 'Nueva Vizcaya', 'NVZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2608, 168, 'Palawan', 'PLW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2609, 168, 'Pampanga', 'PMP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2610, 168, 'Pangasinan', 'PNG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2611, 168, 'Quezon', 'QZN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2612, 168, 'Quirino', 'QRN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2613, 168, 'Rizal', 'RIZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2614, 168, 'Romblon', 'ROM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2615, 168, 'Samar', 'SMR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2616, 168, 'Sarangani', 'SRG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2617, 168, 'Siquijor', 'SQJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2618, 168, 'Sorsogon', 'SRS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2619, 168, 'South Cotabato', 'SCO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2620, 168, 'Southern Leyte', 'SLE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2621, 168, 'Sultan Kudarat', 'SKU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2622, 168, 'Sulu', 'SLU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2623, 168, 'Surigao del Norte', 'SNO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2624, 168, 'Surigao del Sur', 'SSU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2625, 168, 'Tarlac', 'TAR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2626, 168, 'Tawi-Tawi', 'TAW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2627, 168, 'Zambales', 'ZBL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2628, 168, 'Zamboanga del Norte', 'ZNO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2629, 168, 'Zamboanga del Sur', 'ZSU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2630, 168, 'Zamboanga Sibugay', 'ZSI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2631, 170, 'Dolnoslaskie', 'DO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2632, 170, 'Kujawsko-Pomorskie', 'KP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2633, 170, 'Lodzkie', 'LO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2634, 170, 'Lubelskie', 'LL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2635, 170, 'Lubuskie', 'LU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2636, 170, 'Malopolskie', 'ML', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2637, 170, 'Mazowieckie', 'MZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2638, 170, 'Opolskie', 'OP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2639, 170, 'Podkarpackie', 'PP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2640, 170, 'Podlaskie', 'PL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2641, 170, 'Pomorskie', 'PM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2642, 170, 'Slaskie', 'SL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2643, 170, 'Swietokrzyskie', 'SW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2644, 170, 'Warminsko-Mazurskie', 'WM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2645, 170, 'Wielkopolskie', 'WP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2646, 170, 'Zachodniopomorskie', 'ZA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2647, 198, 'Saint Pierre', 'P', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2648, 198, 'Miquelon', 'M', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2649, 171, 'A&ccedil;ores', 'AC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2650, 171, 'Aveiro', 'AV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2651, 171, 'Beja', 'BE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2652, 171, 'Braga', 'BR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2653, 171, 'Bragan&ccedil;a', 'BA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2654, 171, 'Castelo Branco', 'CB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2655, 171, 'Coimbra', 'CO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2656, 171, '&Eacute;vora', 'EV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2657, 171, 'Faro', 'FA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2658, 171, 'Guarda', 'GU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2659, 171, 'Leiria', 'LE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2660, 171, 'Lisboa', 'LI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2661, 171, 'Madeira', 'ME', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2662, 171, 'Portalegre', 'PO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2663, 171, 'Porto', 'PR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2664, 171, 'Santar&eacute;m', 'SA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2665, 171, 'Set&uacute;bal', 'SE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2666, 171, 'Viana do Castelo', 'VC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2667, 171, 'Vila Real', 'VR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2668, 171, 'Viseu', 'VI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2669, 173, 'Ad Dawhah', 'DW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2670, 173, 'Al Ghuwayriyah', 'GW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2671, 173, 'Al Jumayliyah', 'JM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2672, 173, 'Al Khawr', 'KR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2673, 173, 'Al Wakrah', 'WK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2674, 173, 'Ar Rayyan', 'RN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2675, 173, 'Jarayan al Batinah', 'JB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2676, 173, 'Madinat ash Shamal', 'MS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2677, 173, 'Umm Sa''id', 'UD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2678, 173, 'Umm Salal', 'UL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2679, 175, 'Alba', 'AB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2680, 175, 'Arad', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2681, 175, 'Arges', 'AG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2682, 175, 'Bacau', 'BC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2683, 175, 'Bihor', 'BH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2684, 175, 'Bistrita-Nasaud', 'BN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2685, 175, 'Botosani', 'BT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2686, 175, 'Brasov', 'BV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2687, 175, 'Braila', 'BR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2688, 175, 'Bucuresti', 'B', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2689, 175, 'Buzau', 'BZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2690, 175, 'Caras-Severin', 'CS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2691, 175, 'Calarasi', 'CL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2692, 175, 'Cluj', 'CJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2693, 175, 'Constanta', 'CT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2694, 175, 'Covasna', 'CV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2695, 175, 'Dimbovita', 'DB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2696, 175, 'Dolj', 'DJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2697, 175, 'Galati', 'GL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2698, 175, 'Giurgiu', 'GR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2699, 175, 'Gorj', 'GJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2700, 175, 'Harghita', 'HR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2701, 175, 'Hunedoara', 'HD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2702, 175, 'Ialomita', 'IL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2703, 175, 'Iasi', 'IS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2704, 175, 'Ilfov', 'IF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2705, 175, 'Maramures', 'MM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2706, 175, 'Mehedinti', 'MH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2707, 175, 'Mures', 'MS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2708, 175, 'Neamt', 'NT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2709, 175, 'Olt', 'OT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2710, 175, 'Prahova', 'PH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2711, 175, 'Satu-Mare', 'SM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2712, 175, 'Salaj', 'SJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2713, 175, 'Sibiu', 'SB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2714, 175, 'Suceava', 'SV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2715, 175, 'Teleorman', 'TR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2716, 175, 'Timis', 'TM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2717, 175, 'Tulcea', 'TL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2718, 175, 'Vaslui', 'VS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2719, 175, 'Valcea', 'VL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2720, 175, 'Vrancea', 'VN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2721, 176, 'Abakan', 'AB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2722, 176, 'Aginskoye', 'AG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2723, 176, 'Anadyr', 'AN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2724, 176, 'Arkahangelsk', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2725, 176, 'Astrakhan', 'AS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2726, 176, 'Barnaul', 'BA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2727, 176, 'Belgorod', 'BE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2728, 176, 'Birobidzhan', 'BI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2729, 176, 'Blagoveshchensk', 'BL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2730, 176, 'Bryansk', 'BR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2731, 176, 'Cheboksary', 'CH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2732, 176, 'Chelyabinsk', 'CL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2733, 176, 'Cherkessk', 'CR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2734, 176, 'Chita', 'CI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2735, 176, 'Dudinka', 'DU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2736, 176, 'Elista', 'EL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2737, 176, 'Gomo-Altaysk', 'GO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2738, 176, 'Gorno-Altaysk', 'GA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2739, 176, 'Groznyy', 'GR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2740, 176, 'Irkutsk', 'IR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2741, 176, 'Ivanovo', 'IV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2742, 176, 'Izhevsk', 'IZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2743, 176, 'Kalinigrad', 'KA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2744, 176, 'Kaluga', 'KL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2745, 176, 'Kasnodar', 'KS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2746, 176, 'Kazan', 'KZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2747, 176, 'Kemerovo', 'KE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2748, 176, 'Khabarovsk', 'KH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2749, 176, 'Khanty-Mansiysk', 'KM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2750, 176, 'Kostroma', 'KO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2751, 176, 'Krasnodar', 'KR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2752, 176, 'Krasnoyarsk', 'KN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2753, 176, 'Kudymkar', 'KU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2754, 176, 'Kurgan', 'KG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2755, 176, 'Kursk', 'KK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2756, 176, 'Kyzyl', 'KY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2757, 176, 'Lipetsk', 'LI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2758, 176, 'Magadan', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2759, 176, 'Makhachkala', 'MK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2760, 176, 'Maykop', 'MY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2761, 176, 'Moscow', 'MO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2762, 176, 'Murmansk', 'MU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2763, 176, 'Nalchik', 'NA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2764, 176, 'Naryan Mar', 'NR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2765, 176, 'Nazran', 'NZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2766, 176, 'Nizhniy Novgorod', 'NI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2767, 176, 'Novgorod', 'NO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2768, 176, 'Novosibirsk', 'NV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2769, 176, 'Omsk', 'OM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2770, 176, 'Orel', 'OR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2771, 176, 'Orenburg', 'OE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2772, 176, 'Palana', 'PA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2773, 176, 'Penza', 'PE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2774, 176, 'Perm', 'PR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2775, 176, 'Petropavlovsk-Kamchatskiy', 'PK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2776, 176, 'Petrozavodsk', 'PT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2777, 176, 'Pskov', 'PS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2778, 176, 'Rostov-na-Donu', 'RO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2779, 176, 'Ryazan', 'RY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2780, 176, 'Salekhard', 'SL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2781, 176, 'Samara', 'SA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2782, 176, 'Saransk', 'SR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2783, 176, 'Saratov', 'SV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2784, 176, 'Smolensk', 'SM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2785, 176, 'St. Petersburg', 'SP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2786, 176, 'Stavropol', 'ST', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2787, 176, 'Syktyvkar', 'SY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2788, 176, 'Tambov', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2789, 176, 'Tomsk', 'TO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2790, 176, 'Tula', 'TU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2791, 176, 'Tura', 'TR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2792, 176, 'Tver', 'TV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2793, 176, 'Tyumen', 'TY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2794, 176, 'Ufa', 'UF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2795, 176, 'Ul''yanovsk', 'UL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2796, 176, 'Ulan-Ude', 'UU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2797, 176, 'Ust''-Ordynskiy', 'US', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2798, 176, 'Vladikavkaz', 'VL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2799, 176, 'Vladimir', 'VA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2800, 176, 'Vladivostok', 'VV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2801, 176, 'Volgograd', 'VG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2802, 176, 'Vologda', 'VD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2803, 176, 'Voronezh', 'VO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2804, 176, 'Vyatka', 'VY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2805, 176, 'Yakutsk', 'YA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2806, 176, 'Yaroslavl', 'YR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2807, 176, 'Yekaterinburg', 'YE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2808, 176, 'Yoshkar-Ola', 'YO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2809, 177, 'Butare', 'BU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2810, 177, 'Byumba', 'BY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2811, 177, 'Cyangugu', 'CY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2812, 177, 'Gikongoro', 'GK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2813, 177, 'Gisenyi', 'GS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2814, 177, 'Gitarama', 'GT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2815, 177, 'Kibungo', 'KG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2816, 177, 'Kibuye', 'KY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2817, 177, 'Kigali Rurale', 'KR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2818, 177, 'Kigali-ville', 'KV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2819, 177, 'Ruhengeri', 'RU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2820, 177, 'Umutara', 'UM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2821, 178, 'Christ Church Nichola Town', 'CCN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2822, 178, 'Saint Anne Sandy Point', 'SAS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2823, 178, 'Saint George Basseterre', 'SGB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2824, 178, 'Saint George Gingerland', 'SGG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2825, 178, 'Saint James Windward', 'SJW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2826, 178, 'Saint John Capesterre', 'SJC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2827, 178, 'Saint John Figtree', 'SJF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2828, 178, 'Saint Mary Cayon', 'SMC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2829, 178, 'Saint Paul Capesterre', 'CAP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2830, 178, 'Saint Paul Charlestown', 'CHA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2831, 178, 'Saint Peter Basseterre', 'SPB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2832, 178, 'Saint Thomas Lowland', 'STL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2833, 178, 'Saint Thomas Middle Island', 'STM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2834, 178, 'Trinity Palmetto Point', 'TPP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2835, 179, 'Anse-la-Raye', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2836, 179, 'Castries', 'CA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2837, 179, 'Choiseul', 'CH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2838, 179, 'Dauphin', 'DA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2839, 179, 'Dennery', 'DE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2840, 179, 'Gros-Islet', 'GI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2841, 179, 'Laborie', 'LA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2842, 179, 'Micoud', 'MI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2843, 179, 'Praslin', 'PR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2844, 179, 'Soufriere', 'SO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2845, 179, 'Vieux-Fort', 'VF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2846, 180, 'Charlotte', 'C', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2847, 180, 'Grenadines', 'R', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2848, 180, 'Saint Andrew', 'A', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2849, 180, 'Saint David', 'D', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2850, 180, 'Saint George', 'G', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2851, 180, 'Saint Patrick', 'P', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2852, 181, 'A''ana', 'AN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2853, 181, 'Aiga-i-le-Tai', 'AI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2854, 181, 'Atua', 'AT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2855, 181, 'Fa''asaleleaga', 'FA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2856, 181, 'Gaga''emauga', 'GE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2857, 181, 'Gagaifomauga', 'GF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2858, 181, 'Palauli', 'PA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2859, 181, 'Satupa''itea', 'SA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2860, 181, 'Tuamasaga', 'TU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2861, 181, 'Va''a-o-Fonoti', 'VF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2862, 181, 'Vaisigano', 'VS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2863, 182, 'Acquaviva', 'AC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2864, 182, 'Borgo Maggiore', 'BM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2865, 182, 'Chiesanuova', 'CH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2866, 182, 'Domagnano', 'DO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2867, 182, 'Faetano', 'FA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2868, 182, 'Fiorentino', 'FI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2869, 182, 'Montegiardino', 'MO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2870, 182, 'Citta di San Marino', 'SM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2871, 182, 'Serravalle', 'SE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2872, 183, 'Sao Tome', 'S', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2873, 183, 'Principe', 'P', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2874, 184, 'Al Bahah', 'BH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2875, 184, 'Al Hudud ash Shamaliyah', 'HS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2876, 184, 'Al Jawf', 'JF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2877, 184, 'Al Madinah', 'MD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2878, 184, 'Al Qasim', 'QS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2879, 184, 'Ar Riyad', 'RD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2880, 184, 'Ash Sharqiyah (Eastern)', 'AQ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2881, 184, '''Asir', 'AS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2882, 184, 'Ha''il', 'HL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2883, 184, 'Jizan', 'JZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2884, 184, 'Makkah', 'ML', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2885, 184, 'Najran', 'NR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2886, 184, 'Tabuk', 'TB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2887, 185, 'Dakar', 'DA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2888, 185, 'Diourbel', 'DI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2889, 185, 'Fatick', 'FA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2890, 185, 'Kaolack', 'KA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2891, 185, 'Kolda', 'KO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2892, 185, 'Louga', 'LO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2893, 185, 'Matam', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2894, 185, 'Saint-Louis', 'SL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2895, 185, 'Tambacounda', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2896, 185, 'Thies', 'TH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2897, 185, 'Ziguinchor', 'ZI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2898, 186, 'Anse aux Pins', 'AP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2899, 186, 'Anse Boileau', 'AB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2900, 186, 'Anse Etoile', 'AE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2901, 186, 'Anse Louis', 'AL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2902, 186, 'Anse Royale', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2903, 186, 'Baie Lazare', 'BL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2904, 186, 'Baie Sainte Anne', 'BS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2905, 186, 'Beau Vallon', 'BV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2906, 186, 'Bel Air', 'BA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2907, 186, 'Bel Ombre', 'BO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2908, 186, 'Cascade', 'CA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2909, 186, 'Glacis', 'GL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2910, 186, 'Grand'' Anse (on Mahe)', 'GM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2911, 186, 'Grand'' Anse (on Praslin)', 'GP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2912, 186, 'La Digue', 'DG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2913, 186, 'La Riviere Anglaise', 'RA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2914, 186, 'Mont Buxton', 'MB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2915, 186, 'Mont Fleuri', 'MF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2916, 186, 'Plaisance', 'PL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2917, 186, 'Pointe La Rue', 'PR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2918, 186, 'Port Glaud', 'PG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2919, 186, 'Saint Louis', 'SL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2920, 186, 'Takamaka', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2921, 187, 'Eastern', 'E', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24');
INSERT INTO `mw_zone` (`zone_id`, `country_id`, `name`, `code`, `status`, `date_added`, `last_updated`) VALUES
(2922, 187, 'Northern', 'N', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2923, 187, 'Southern', 'S', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2924, 187, 'Western', 'W', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2925, 189, 'Banskobystrický', 'BA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2926, 189, 'Bratislavský', 'BR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2927, 189, 'Košický', 'KO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2928, 189, 'Nitriansky', 'NI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2929, 189, 'Prešovský', 'PR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2930, 189, 'Trenčiansky', 'TC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2931, 189, 'Trnavský', 'TV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2932, 189, 'Žilinský', 'ZI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2933, 191, 'Central', 'CE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2934, 191, 'Choiseul', 'CH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2935, 191, 'Guadalcanal', 'GC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2936, 191, 'Honiara', 'HO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2937, 191, 'Isabel', 'IS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2938, 191, 'Makira', 'MK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2939, 191, 'Malaita', 'ML', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2940, 191, 'Rennell and Bellona', 'RB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2941, 191, 'Temotu', 'TM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2942, 191, 'Western', 'WE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2943, 192, 'Awdal', 'AW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2944, 192, 'Bakool', 'BK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2945, 192, 'Banaadir', 'BN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2946, 192, 'Bari', 'BR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2947, 192, 'Bay', 'BY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2948, 192, 'Galguduud', 'GA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2949, 192, 'Gedo', 'GE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2950, 192, 'Hiiraan', 'HI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2951, 192, 'Jubbada Dhexe', 'JD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2952, 192, 'Jubbada Hoose', 'JH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2953, 192, 'Mudug', 'MU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2954, 192, 'Nugaal', 'NU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2955, 192, 'Sanaag', 'SA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2956, 192, 'Shabeellaha Dhexe', 'SD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2957, 192, 'Shabeellaha Hoose', 'SH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2958, 192, 'Sool', 'SL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2959, 192, 'Togdheer', 'TO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2960, 192, 'Woqooyi Galbeed', 'WG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2961, 193, 'Eastern Cape', 'EC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2962, 193, 'Free State', 'FS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2963, 193, 'Gauteng', 'GT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2964, 193, 'KwaZulu-Natal', 'KN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2965, 193, 'Limpopo', 'LP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2966, 193, 'Mpumalanga', 'MP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2967, 193, 'North West', 'NW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2968, 193, 'Northern Cape', 'NC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2969, 193, 'Western Cape', 'WC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2970, 195, 'La Coru&ntilde;a', 'CA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2971, 195, '&Aacute;lava', 'AL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2972, 195, 'Albacete', 'AB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2973, 195, 'Alicante', 'AC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2974, 195, 'Almeria', 'AM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2975, 195, 'Asturias', 'AS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2976, 195, '&Aacute;vila', 'AV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2977, 195, 'Badajoz', 'BJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2978, 195, 'Baleares', 'IB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2979, 195, 'Barcelona', 'BA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2980, 195, 'Burgos', 'BU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2981, 195, 'C&aacute;ceres', 'CC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2982, 195, 'C&aacute;diz', 'CZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2983, 195, 'Cantabria', 'CT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2984, 195, 'Castell&oacute;n', 'CL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2985, 195, 'Ceuta', 'CE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2986, 195, 'Ciudad Real', 'CR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2987, 195, 'C&oacute;rdoba', 'CD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2988, 195, 'Cuenca', 'CU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2989, 195, 'Girona', 'GI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2990, 195, 'Granada', 'GD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2991, 195, 'Guadalajara', 'GJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2992, 195, 'Guip&uacute;zcoa', 'GP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2993, 195, 'Huelva', 'HL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2994, 195, 'Huesca', 'HS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2995, 195, 'Ja&eacute;n', 'JN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2996, 195, 'La Rioja', 'RJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2997, 195, 'Las Palmas', 'PM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2998, 195, 'Leon', 'LE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(2999, 195, 'Lleida', 'LL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3000, 195, 'Lugo', 'LG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3001, 195, 'Madrid', 'MD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3002, 195, 'Malaga', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3003, 195, 'Melilla', 'ML', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3004, 195, 'Murcia', 'MU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3005, 195, 'Navarra', 'NV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3006, 195, 'Ourense', 'OU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3007, 195, 'Palencia', 'PL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3008, 195, 'Pontevedra', 'PO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3009, 195, 'Salamanca', 'SL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3010, 195, 'Santa Cruz de Tenerife', 'SC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3011, 195, 'Segovia', 'SG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3012, 195, 'Sevilla', 'SV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3013, 195, 'Soria', 'SO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3014, 195, 'Tarragona', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3015, 195, 'Teruel', 'TE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3016, 195, 'Toledo', 'TO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3017, 195, 'Valencia', 'VC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3018, 195, 'Valladolid', 'VD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3019, 195, 'Vizcaya', 'VZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3020, 195, 'Zamora', 'ZM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3021, 195, 'Zaragoza', 'ZR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3022, 196, 'Central', 'CE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3023, 196, 'Eastern', 'EA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3024, 196, 'North Central', 'NC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3025, 196, 'Northern', 'NO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3026, 196, 'North Western', 'NW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3027, 196, 'Sabaragamuwa', 'SA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3028, 196, 'Southern', 'SO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3029, 196, 'Uva', 'UV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3030, 196, 'Western', 'WE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3031, 197, 'Ascension', 'A', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3032, 197, 'Saint Helena', 'S', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3033, 197, 'Tristan da Cunha', 'T', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3034, 199, 'A''ali an Nil', 'ANL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3035, 199, 'Al Bahr al Ahmar', 'BAM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3036, 199, 'Al Buhayrat', 'BRT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3037, 199, 'Al Jazirah', 'JZR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3038, 199, 'Al Khartum', 'KRT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3039, 199, 'Al Qadarif', 'QDR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3040, 199, 'Al Wahdah', 'WDH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3041, 199, 'An Nil al Abyad', 'ANB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3042, 199, 'An Nil al Azraq', 'ANZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3043, 199, 'Ash Shamaliyah', 'ASH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3044, 199, 'Bahr al Jabal', 'BJA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3045, 199, 'Gharb al Istiwa''iyah', 'GIS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3046, 199, 'Gharb Bahr al Ghazal', 'GBG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3047, 199, 'Gharb Darfur', 'GDA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3048, 199, 'Gharb Kurdufan', 'GKU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3049, 199, 'Janub Darfur', 'JDA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3050, 199, 'Janub Kurdufan', 'JKU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3051, 199, 'Junqali', 'JQL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3052, 199, 'Kassala', 'KSL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3053, 199, 'Nahr an Nil', 'NNL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3054, 199, 'Shamal Bahr al Ghazal', 'SBG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3055, 199, 'Shamal Darfur', 'SDA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3056, 199, 'Shamal Kurdufan', 'SKU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3057, 199, 'Sharq al Istiwa''iyah', 'SIS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3058, 199, 'Sinnar', 'SNR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3059, 199, 'Warab', 'WRB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3060, 200, 'Brokopondo', 'BR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3061, 200, 'Commewijne', 'CM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3062, 200, 'Coronie', 'CR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3063, 200, 'Marowijne', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3064, 200, 'Nickerie', 'NI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3065, 200, 'Para', 'PA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3066, 200, 'Paramaribo', 'PM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3067, 200, 'Saramacca', 'SA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3068, 200, 'Sipaliwini', 'SI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3069, 200, 'Wanica', 'WA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3070, 202, 'Hhohho', 'H', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3071, 202, 'Lubombo', 'L', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3072, 202, 'Manzini', 'M', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3073, 202, 'Shishelweni', 'S', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3074, 203, 'Blekinge', 'K', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3075, 203, 'Dalarna', 'W', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3076, 203, 'G&auml;vleborg', 'X', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3077, 203, 'Gotland', 'I', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3078, 203, 'Halland', 'N', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3079, 203, 'J&auml;mtland', 'Z', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3080, 203, 'J&ouml;nk&ouml;ping', 'F', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3081, 203, 'Kalmar', 'H', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3082, 203, 'Kronoberg', 'G', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3083, 203, 'Norrbotten', 'BD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3084, 203, '&Ouml;rebro', 'T', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3085, 203, '&Ouml;sterg&ouml;tland', 'E', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3086, 203, 'Sk&aring;ne', 'M', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3087, 203, 'S&ouml;dermanland', 'D', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3088, 203, 'Stockholm', 'AB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3089, 203, 'Uppsala', 'C', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3090, 203, 'V&auml;rmland', 'S', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3091, 203, 'V&auml;sterbotten', 'AC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3092, 203, 'V&auml;sternorrland', 'Y', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3093, 203, 'V&auml;stmanland', 'U', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3094, 203, 'V&auml;stra G&ouml;taland', 'O', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3095, 204, 'Aargau', 'AG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3096, 204, 'Appenzell Ausserrhoden', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3097, 204, 'Appenzell Innerrhoden', 'AI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3098, 204, 'Basel-Stadt', 'BS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3099, 204, 'Basel-Landschaft', 'BL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3100, 204, 'Bern', 'BE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3101, 204, 'Fribourg', 'FR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3102, 204, 'Gen&egrave;ve', 'GE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3103, 204, 'Glarus', 'GL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3104, 204, 'Graub&uuml;nden', 'GR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3105, 204, 'Jura', 'JU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3106, 204, 'Luzern', 'LU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3107, 204, 'Neuch&acirc;tel', 'NE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3108, 204, 'Nidwald', 'NW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3109, 204, 'Obwald', 'OW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3110, 204, 'St. Gallen', 'SG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3111, 204, 'Schaffhausen', 'SH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3112, 204, 'Schwyz', 'SZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3113, 204, 'Solothurn', 'SO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3114, 204, 'Thurgau', 'TG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3115, 204, 'Ticino', 'TI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3116, 204, 'Uri', 'UR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3117, 204, 'Valais', 'VS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3118, 204, 'Vaud', 'VD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3119, 204, 'Zug', 'ZG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3120, 204, 'Z&uuml;rich', 'ZH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3121, 205, 'Al Hasakah', 'HA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3122, 205, 'Al Ladhiqiyah', 'LA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3123, 205, 'Al Qunaytirah', 'QU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3124, 205, 'Ar Raqqah', 'RQ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3125, 205, 'As Suwayda', 'SU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3126, 205, 'Dara', 'DA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3127, 205, 'Dayr az Zawr', 'DZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3128, 205, 'Dimashq', 'DI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3129, 205, 'Halab', 'HL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3130, 205, 'Hamah', 'HM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3131, 205, 'Hims', 'HI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3132, 205, 'Idlib', 'ID', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3133, 205, 'Rif Dimashq', 'RD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3134, 205, 'Tartus', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3135, 206, 'Chang-hua', 'CH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3136, 206, 'Chia-i', 'CI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3137, 206, 'Hsin-chu', 'HS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3138, 206, 'Hua-lien', 'HL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3139, 206, 'I-lan', 'IL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3140, 206, 'Kao-hsiung county', 'KH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3141, 206, 'Kin-men', 'KM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3142, 206, 'Lien-chiang', 'LC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3143, 206, 'Miao-li', 'ML', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3144, 206, 'Nan-t''ou', 'NT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3145, 206, 'P''eng-hu', 'PH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3146, 206, 'P''ing-tung', 'PT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3147, 206, 'T''ai-chung', 'TG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3148, 206, 'T''ai-nan', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3149, 206, 'T''ai-pei county', 'TP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3150, 206, 'T''ai-tung', 'TT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3151, 206, 'T''ao-yuan', 'TY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3152, 206, 'Yun-lin', 'YL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3153, 206, 'Chia-i city', 'CC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3154, 206, 'Chi-lung', 'CL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3155, 206, 'Hsin-chu', 'HC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3156, 206, 'T''ai-chung', 'TH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3157, 206, 'T''ai-nan', 'TN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3158, 206, 'Kao-hsiung city', 'KC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3159, 206, 'T''ai-pei city', 'TC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3160, 207, 'Gorno-Badakhstan', 'GB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3161, 207, 'Khatlon', 'KT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3162, 207, 'Sughd', 'SU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3163, 208, 'Arusha', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3164, 208, 'Dar es Salaam', 'DS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3165, 208, 'Dodoma', 'DO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3166, 208, 'Iringa', 'IR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3167, 208, 'Kagera', 'KA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3168, 208, 'Kigoma', 'KI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3169, 208, 'Kilimanjaro', 'KJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3170, 208, 'Lindi', 'LN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3171, 208, 'Manyara', 'MY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3172, 208, 'Mara', 'MR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3173, 208, 'Mbeya', 'MB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3174, 208, 'Morogoro', 'MO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3175, 208, 'Mtwara', 'MT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3176, 208, 'Mwanza', 'MW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3177, 208, 'Pemba North', 'PN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3178, 208, 'Pemba South', 'PS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3179, 208, 'Pwani', 'PW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3180, 208, 'Rukwa', 'RK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3181, 208, 'Ruvuma', 'RV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3182, 208, 'Shinyanga', 'SH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3183, 208, 'Singida', 'SI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3184, 208, 'Tabora', 'TB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3185, 208, 'Tanga', 'TN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3186, 208, 'Zanzibar Central/South', 'ZC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3187, 208, 'Zanzibar North', 'ZN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3188, 208, 'Zanzibar Urban/West', 'ZU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3189, 209, 'Amnat Charoen', 'Amnat Charoen', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3190, 209, 'Ang Thong', 'Ang Thong', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3191, 209, 'Ayutthaya', 'Ayutthaya', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3192, 209, 'Bangkok', 'Bangkok', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3193, 209, 'Buriram', 'Buriram', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3194, 209, 'Chachoengsao', 'Chachoengsao', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3195, 209, 'Chai Nat', 'Chai Nat', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3196, 209, 'Chaiyaphum', 'Chaiyaphum', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3197, 209, 'Chanthaburi', 'Chanthaburi', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3198, 209, 'Chiang Mai', 'Chiang Mai', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3199, 209, 'Chiang Rai', 'Chiang Rai', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3200, 209, 'Chon Buri', 'Chon Buri', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3201, 209, 'Chumphon', 'Chumphon', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3202, 209, 'Kalasin', 'Kalasin', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3203, 209, 'Kamphaeng Phet', 'Kamphaeng Phet', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3204, 209, 'Kanchanaburi', 'Kanchanaburi', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3205, 209, 'Khon Kaen', 'Khon Kaen', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3206, 209, 'Krabi', 'Krabi', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3207, 209, 'Lampang', 'Lampang', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3208, 209, 'Lamphun', 'Lamphun', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3209, 209, 'Loei', 'Loei', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3210, 209, 'Lop Buri', 'Lop Buri', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3211, 209, 'Mae Hong Son', 'Mae Hong Son', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3212, 209, 'Maha Sarakham', 'Maha Sarakham', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3213, 209, 'Mukdahan', 'Mukdahan', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3214, 209, 'Nakhon Nayok', 'Nakhon Nayok', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3215, 209, 'Nakhon Pathom', 'Nakhon Pathom', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3216, 209, 'Nakhon Phanom', 'Nakhon Phanom', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3217, 209, 'Nakhon Ratchasima', 'Nakhon Ratchasima', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3218, 209, 'Nakhon Sawan', 'Nakhon Sawan', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3219, 209, 'Nakhon Si Thammarat', 'Nakhon Si Thammarat', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3220, 209, 'Nan', 'Nan', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3221, 209, 'Narathiwat', 'Narathiwat', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3222, 209, 'Nong Bua Lamphu', 'Nong Bua Lamphu', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3223, 209, 'Nong Khai', 'Nong Khai', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3224, 209, 'Nonthaburi', 'Nonthaburi', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3225, 209, 'Pathum Thani', 'Pathum Thani', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3226, 209, 'Pattani', 'Pattani', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3227, 209, 'Phangnga', 'Phangnga', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3228, 209, 'Phatthalung', 'Phatthalung', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3229, 209, 'Phayao', 'Phayao', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3230, 209, 'Phetchabun', 'Phetchabun', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3231, 209, 'Phetchaburi', 'Phetchaburi', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3232, 209, 'Phichit', 'Phichit', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3233, 209, 'Phitsanulok', 'Phitsanulok', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3234, 209, 'Phrae', 'Phrae', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3235, 209, 'Phuket', 'Phuket', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3236, 209, 'Prachin Buri', 'Prachin Buri', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3237, 209, 'Prachuap Khiri Khan', 'Prachuap Khiri Khan', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3238, 209, 'Ranong', 'Ranong', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3239, 209, 'Ratchaburi', 'Ratchaburi', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3240, 209, 'Rayong', 'Rayong', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3241, 209, 'Roi Et', 'Roi Et', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3242, 209, 'Sa Kaeo', 'Sa Kaeo', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3243, 209, 'Sakon Nakhon', 'Sakon Nakhon', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3244, 209, 'Samut Prakan', 'Samut Prakan', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3245, 209, 'Samut Sakhon', 'Samut Sakhon', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3246, 209, 'Samut Songkhram', 'Samut Songkhram', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3247, 209, 'Sara Buri', 'Sara Buri', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3248, 209, 'Satun', 'Satun', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3249, 209, 'Sing Buri', 'Sing Buri', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3250, 209, 'Sisaket', 'Sisaket', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3251, 209, 'Songkhla', 'Songkhla', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3252, 209, 'Sukhothai', 'Sukhothai', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3253, 209, 'Suphan Buri', 'Suphan Buri', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3254, 209, 'Surat Thani', 'Surat Thani', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3255, 209, 'Surin', 'Surin', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3256, 209, 'Tak', 'Tak', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3257, 209, 'Trang', 'Trang', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3258, 209, 'Trat', 'Trat', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3259, 209, 'Ubon Ratchathani', 'Ubon Ratchathani', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3260, 209, 'Udon Thani', 'Udon Thani', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3261, 209, 'Uthai Thani', 'Uthai Thani', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3262, 209, 'Uttaradit', 'Uttaradit', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3263, 209, 'Yala', 'Yala', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3264, 209, 'Yasothon', 'Yasothon', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3265, 210, 'Kara', 'K', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3266, 210, 'Plateaux', 'P', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3267, 210, 'Savanes', 'S', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3268, 210, 'Centrale', 'C', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3269, 210, 'Maritime', 'M', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3270, 211, 'Atafu', 'A', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3271, 211, 'Fakaofo', 'F', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3272, 211, 'Nukunonu', 'N', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3273, 212, 'Ha''apai', 'H', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3274, 212, 'Tongatapu', 'T', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3275, 212, 'Vava''u', 'V', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3276, 213, 'Couva/Tabaquite/Talparo', 'CT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3277, 213, 'Diego Martin', 'DM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3278, 213, 'Mayaro/Rio Claro', 'MR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3279, 213, 'Penal/Debe', 'PD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3280, 213, 'Princes Town', 'PT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3281, 213, 'Sangre Grande', 'SG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3282, 213, 'San Juan/Laventille', 'SL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3283, 213, 'Siparia', 'SI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3284, 213, 'Tunapuna/Piarco', 'TP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3285, 213, 'Port of Spain', 'PS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3286, 213, 'San Fernando', 'SF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3287, 213, 'Arima', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3288, 213, 'Point Fortin', 'PF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3289, 213, 'Chaguanas', 'CH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3290, 213, 'Tobago', 'TO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3291, 214, 'Ariana', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3292, 214, 'Beja', 'BJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3293, 214, 'Ben Arous', 'BA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3294, 214, 'Bizerte', 'BI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3295, 214, 'Gabes', 'GB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3296, 214, 'Gafsa', 'GF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3297, 214, 'Jendouba', 'JE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3298, 214, 'Kairouan', 'KR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3299, 214, 'Kasserine', 'KS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3300, 214, 'Kebili', 'KB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3301, 214, 'Kef', 'KF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3302, 214, 'Mahdia', 'MH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3303, 214, 'Manouba', 'MN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3304, 214, 'Medenine', 'ME', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3305, 214, 'Monastir', 'MO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3306, 214, 'Nabeul', 'NA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3307, 214, 'Sfax', 'SF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3308, 214, 'Sidi', 'SD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3309, 214, 'Siliana', 'SL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3310, 214, 'Sousse', 'SO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3311, 214, 'Tataouine', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3312, 214, 'Tozeur', 'TO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3313, 214, 'Tunis', 'TU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3314, 214, 'Zaghouan', 'ZA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3315, 215, 'Adana', 'ADA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3316, 215, 'Adıyaman', 'ADI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3317, 215, 'Afyonkarahisar', 'AFY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3318, 215, 'Ağrı', 'AGR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3319, 215, 'Aksaray', 'AKS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3320, 215, 'Amasya', 'AMA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3321, 215, 'Ankara', 'ANK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3322, 215, 'Antalya', 'ANT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3323, 215, 'Ardahan', 'ARD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3324, 215, 'Artvin', 'ART', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3325, 215, 'Aydın', 'AYI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3326, 215, 'Balıkesir', 'BAL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3327, 215, 'Bartın', 'BAR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3328, 215, 'Batman', 'BAT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3329, 215, 'Bayburt', 'BAY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3330, 215, 'Bilecik', 'BIL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3331, 215, 'Bingöl', 'BIN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3332, 215, 'Bitlis', 'BIT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3333, 215, 'Bolu', 'BOL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3334, 215, 'Burdur', 'BRD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3335, 215, 'Bursa', 'BRS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3336, 215, 'Çanakkale', 'CKL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3337, 215, 'Çankırı', 'CKR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3338, 215, 'Çorum', 'COR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3339, 215, 'Denizli', 'DEN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3340, 215, 'Diyarbakir', 'DIY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3341, 215, 'Düzce', 'DUZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3342, 215, 'Edirne', 'EDI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3343, 215, 'Elazig', 'ELA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3344, 215, 'Erzincan', 'EZC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3345, 215, 'Erzurum', 'EZR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3346, 215, 'Eskişehir', 'ESK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3347, 215, 'Gaziantep', 'GAZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3348, 215, 'Giresun', 'GIR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3349, 215, 'Gümüşhane', 'GMS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3350, 215, 'Hakkari', 'HKR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3351, 215, 'Hatay', 'HTY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3352, 215, 'Iğdır', 'IGD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3353, 215, 'Isparta', 'ISP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3354, 215, 'İstanbul', 'IST', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3355, 215, 'İzmir', 'IZM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3356, 215, 'Kahramanmaraş', 'KAH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3357, 215, 'Karabük', 'KRB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3358, 215, 'Karaman', 'KRM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3359, 215, 'Kars', 'KRS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3360, 215, 'Kastamonu', 'KAS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3361, 215, 'Kayseri', 'KAY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3362, 215, 'Kilis', 'KLS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3363, 215, 'Kirikkale', 'KRK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3364, 215, 'Kirklareli', 'KLR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3365, 215, 'Kirsehir', 'KRH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3366, 215, 'Kocaeli', 'KOC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3367, 215, 'Konya', 'KON', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3368, 215, 'Kütahya', 'KUT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3369, 215, 'Malatya', 'MAL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3370, 215, 'Manisa', 'MAN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3371, 215, 'Mardin', 'MAR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3372, 215, 'Mersin', 'MER', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3373, 215, 'Muğla', 'MUG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3374, 215, 'Muş', 'MUS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3375, 215, 'Nevşehir', 'NEV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3376, 215, 'Niğde', 'NIG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3377, 215, 'Ordu', 'ORD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3378, 215, 'Osmaniye', 'OSM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3379, 215, 'Rize', 'RIZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3380, 215, 'Sakarya', 'SAK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3381, 215, 'Samsun', 'SAM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3382, 215, 'Şanlıurfa', 'SAN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3383, 215, 'Siirt', 'SII', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3384, 215, 'Sinop', 'SIN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3385, 215, 'Şırnak', 'SIR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3386, 215, 'Sivas', 'SIV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3387, 215, 'Tekirdağ', 'TEL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3388, 215, 'Tokat', 'TOK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3389, 215, 'Trabzon', 'TRA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3390, 215, 'Tunceli', 'TUN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3391, 215, 'Uşak', 'USK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3392, 215, 'Van', 'VAN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3393, 215, 'Yalova', 'YAL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3394, 215, 'Yozgat', 'YOZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3395, 215, 'Zonguldak', 'ZON', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3396, 216, 'Ahal Welayaty', 'A', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3397, 216, 'Balkan Welayaty', 'B', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3398, 216, 'Dashhowuz Welayaty', 'D', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3399, 216, 'Lebap Welayaty', 'L', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3400, 216, 'Mary Welayaty', 'M', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3401, 217, 'Ambergris Cays', 'AC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3402, 217, 'Dellis Cay', 'DC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3403, 217, 'French Cay', 'FC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3404, 217, 'Little Water Cay', 'LW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3405, 217, 'Parrot Cay', 'RC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3406, 217, 'Pine Cay', 'PN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3407, 217, 'Salt Cay', 'SL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3408, 217, 'Grand Turk', 'GT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3409, 217, 'South Caicos', 'SC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3410, 217, 'East Caicos', 'EC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3411, 217, 'Middle Caicos', 'MC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3412, 217, 'North Caicos', 'NC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3413, 217, 'Providenciales', 'PR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3414, 217, 'West Caicos', 'WC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3415, 218, 'Nanumanga', 'NMG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3416, 218, 'Niulakita', 'NLK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3417, 218, 'Niutao', 'NTO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3418, 218, 'Funafuti', 'FUN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3419, 218, 'Nanumea', 'NME', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3420, 218, 'Nui', 'NUI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3421, 218, 'Nukufetau', 'NFT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3422, 218, 'Nukulaelae', 'NLL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3423, 218, 'Vaitupu', 'VAI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3424, 219, 'Kalangala', 'KAL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3425, 219, 'Kampala', 'KMP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3426, 219, 'Kayunga', 'KAY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3427, 219, 'Kiboga', 'KIB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3428, 219, 'Luwero', 'LUW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3429, 219, 'Masaka', 'MAS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3430, 219, 'Mpigi', 'MPI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3431, 219, 'Mubende', 'MUB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3432, 219, 'Mukono', 'MUK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3433, 219, 'Nakasongola', 'NKS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3434, 219, 'Rakai', 'RAK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3435, 219, 'Sembabule', 'SEM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3436, 219, 'Wakiso', 'WAK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3437, 219, 'Bugiri', 'BUG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3438, 219, 'Busia', 'BUS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3439, 219, 'Iganga', 'IGA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3440, 219, 'Jinja', 'JIN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3441, 219, 'Kaberamaido', 'KAB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3442, 219, 'Kamuli', 'KML', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3443, 219, 'Kapchorwa', 'KPC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3444, 219, 'Katakwi', 'KTK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3445, 219, 'Kumi', 'KUM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3446, 219, 'Mayuge', 'MAY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3447, 219, 'Mbale', 'MBA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3448, 219, 'Pallisa', 'PAL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3449, 219, 'Sironko', 'SIR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3450, 219, 'Soroti', 'SOR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3451, 219, 'Tororo', 'TOR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3452, 219, 'Adjumani', 'ADJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3453, 219, 'Apac', 'APC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3454, 219, 'Arua', 'ARU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3455, 219, 'Gulu', 'GUL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3456, 219, 'Kitgum', 'KIT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3457, 219, 'Kotido', 'KOT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3458, 219, 'Lira', 'LIR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3459, 219, 'Moroto', 'MRT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3460, 219, 'Moyo', 'MOY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3461, 219, 'Nakapiripirit', 'NAK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3462, 219, 'Nebbi', 'NEB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3463, 219, 'Pader', 'PAD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3464, 219, 'Yumbe', 'YUM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3465, 219, 'Bundibugyo', 'BUN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3466, 219, 'Bushenyi', 'BSH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3467, 219, 'Hoima', 'HOI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3468, 219, 'Kabale', 'KBL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3469, 219, 'Kabarole', 'KAR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3470, 219, 'Kamwenge', 'KAM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3471, 219, 'Kanungu', 'KAN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3472, 219, 'Kasese', 'KAS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3473, 219, 'Kibaale', 'KBA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3474, 219, 'Kisoro', 'KIS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3475, 219, 'Kyenjojo', 'KYE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3476, 219, 'Masindi', 'MSN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3477, 219, 'Mbarara', 'MBR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3478, 219, 'Ntungamo', 'NTU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3479, 219, 'Rukungiri', 'RUK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3480, 220, 'Cherkasy', 'CK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3481, 220, 'Chernihiv', 'CH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3482, 220, 'Chernivtsi', 'CV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3483, 220, 'Crimea', 'CR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3484, 220, 'Dnipropetrovs''k', 'DN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3485, 220, 'Donets''k', 'DO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3486, 220, 'Ivano-Frankivs''k', 'IV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3487, 220, 'Kharkiv Kherson', 'KL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3488, 220, 'Khmel''nyts''kyy', 'KM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3489, 220, 'Kirovohrad', 'KR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3490, 220, 'Kiev', 'KV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3491, 220, 'Kyyiv', 'KY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3492, 220, 'Luhans''k', 'LU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3493, 220, 'L''viv', 'LV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24');
INSERT INTO `mw_zone` (`zone_id`, `country_id`, `name`, `code`, `status`, `date_added`, `last_updated`) VALUES
(3494, 220, 'Mykolayiv', 'MY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3495, 220, 'Odesa', 'OD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3496, 220, 'Poltava', 'PO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3497, 220, 'Rivne', 'RI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3498, 220, 'Sevastopol', 'SE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3499, 220, 'Sumy', 'SU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3500, 220, 'Ternopil''', 'TE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3501, 220, 'Vinnytsya', 'VI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3502, 220, 'Volyn''', 'VO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3503, 220, 'Zakarpattya', 'ZK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3504, 220, 'Zaporizhzhya', 'ZA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3505, 220, 'Zhytomyr', 'ZH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3506, 221, 'Abu Zaby', 'AZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3507, 221, '''Ajman', 'AJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3508, 221, 'Al Fujayrah', 'FU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3509, 221, 'Ash Shariqah', 'SH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3510, 221, 'Dubayy', 'DU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3511, 221, 'R''as al Khaymah', 'RK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3512, 221, 'Umm al Qaywayn', 'UQ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3513, 222, 'Aberdeen', 'ABN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3514, 222, 'Aberdeenshire', 'ABNS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3515, 222, 'Anglesey', 'ANG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3516, 222, 'Angus', 'AGS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3517, 222, 'Argyll and Bute', 'ARY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3518, 222, 'Bedfordshire', 'BEDS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3519, 222, 'Berkshire', 'BERKS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3520, 222, 'Blaenau Gwent', 'BLA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3521, 222, 'Bridgend', 'BRI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3522, 222, 'Bristol', 'BSTL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3523, 222, 'Buckinghamshire', 'BUCKS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3524, 222, 'Caerphilly', 'CAE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3525, 222, 'Cambridgeshire', 'CAMBS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3526, 222, 'Cardiff', 'CDF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3527, 222, 'Carmarthenshire', 'CARM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3528, 222, 'Ceredigion', 'CDGN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3529, 222, 'Cheshire', 'CHES', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3530, 222, 'Clackmannanshire', 'CLACK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3531, 222, 'Conwy', 'CON', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3532, 222, 'Cornwall', 'CORN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3533, 222, 'Denbighshire', 'DNBG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3534, 222, 'Derbyshire', 'DERBY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3535, 222, 'Devon', 'DVN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3536, 222, 'Dorset', 'DOR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3537, 222, 'Dumfries and Galloway', 'DGL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3538, 222, 'Dundee', 'DUND', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3539, 222, 'Durham', 'DHM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3540, 222, 'East Ayrshire', 'ARYE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3541, 222, 'East Dunbartonshire', 'DUNBE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3542, 222, 'East Lothian', 'LOTE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3543, 222, 'East Renfrewshire', 'RENE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3544, 222, 'East Riding of Yorkshire', 'ERYS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3545, 222, 'East Sussex', 'SXE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3546, 222, 'Edinburgh', 'EDIN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3547, 222, 'Essex', 'ESX', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3548, 222, 'Falkirk', 'FALK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3549, 222, 'Fife', 'FFE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3550, 222, 'Flintshire', 'FLINT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3551, 222, 'Glasgow', 'GLAS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3552, 222, 'Gloucestershire', 'GLOS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3553, 222, 'Greater London', 'LDN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3554, 222, 'Greater Manchester', 'MCH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3555, 222, 'Gwynedd', 'GDD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3556, 222, 'Hampshire', 'HANTS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3557, 222, 'Herefordshire', 'HWR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3558, 222, 'Hertfordshire', 'HERTS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3559, 222, 'Highlands', 'HLD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3560, 222, 'Inverclyde', 'IVER', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3561, 222, 'Isle of Wight', 'IOW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3562, 222, 'Kent', 'KNT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3563, 222, 'Lancashire', 'LANCS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3564, 222, 'Leicestershire', 'LEICS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3565, 222, 'Lincolnshire', 'LINCS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3566, 222, 'Merseyside', 'MSY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3567, 222, 'Merthyr Tydfil', 'MERT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3568, 222, 'Midlothian', 'MLOT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3569, 222, 'Monmouthshire', 'MMOUTH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3570, 222, 'Moray', 'MORAY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3571, 222, 'Neath Port Talbot', 'NPRTAL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3572, 222, 'Newport', 'NEWPT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3573, 222, 'Norfolk', 'NOR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3574, 222, 'North Ayrshire', 'ARYN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3575, 222, 'North Lanarkshire', 'LANN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3576, 222, 'North Yorkshire', 'YSN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3577, 222, 'Northamptonshire', 'NHM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3578, 222, 'Northumberland', 'NLD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3579, 222, 'Nottinghamshire', 'NOT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3580, 222, 'Orkney Islands', 'ORK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3581, 222, 'Oxfordshire', 'OFE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3582, 222, 'Pembrokeshire', 'PEM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3583, 222, 'Perth and Kinross', 'PERTH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3584, 222, 'Powys', 'PWS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3585, 222, 'Renfrewshire', 'REN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3586, 222, 'Rhondda Cynon Taff', 'RHON', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3587, 222, 'Rutland', 'RUT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3588, 222, 'Scottish Borders', 'BOR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3589, 222, 'Shetland Islands', 'SHET', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3590, 222, 'Shropshire', 'SPE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3591, 222, 'Somerset', 'SOM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3592, 222, 'South Ayrshire', 'ARYS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3593, 222, 'South Lanarkshire', 'LANS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3594, 222, 'South Yorkshire', 'YSS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3595, 222, 'Staffordshire', 'SFD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3596, 222, 'Stirling', 'STIR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3597, 222, 'Suffolk', 'SFK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3598, 222, 'Surrey', 'SRY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3599, 222, 'Swansea', 'SWAN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3600, 222, 'Torfaen', 'TORF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3601, 222, 'Tyne and Wear', 'TWR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3602, 222, 'Vale of Glamorgan', 'VGLAM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3603, 222, 'Warwickshire', 'WARKS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3604, 222, 'West Dunbartonshire', 'WDUN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3605, 222, 'West Lothian', 'WLOT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3606, 222, 'West Midlands', 'WMD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3607, 222, 'West Sussex', 'SXW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3608, 222, 'West Yorkshire', 'YSW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3609, 222, 'Western Isles', 'WIL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3610, 222, 'Wiltshire', 'WLT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3611, 222, 'Worcestershire', 'WORCS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3612, 222, 'Wrexham', 'WRX', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3613, 223, 'Alabama', 'AL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3614, 223, 'Alaska', 'AK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3615, 223, 'American Samoa', 'AS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3616, 223, 'Arizona', 'AZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3617, 223, 'Arkansas', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3618, 223, 'Armed Forces Africa', 'AF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3619, 223, 'Armed Forces Americas', 'AA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3620, 223, 'Armed Forces Canada', 'AC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3621, 223, 'Armed Forces Europe', 'AE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3622, 223, 'Armed Forces Middle East', 'AM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3623, 223, 'Armed Forces Pacific', 'AP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3624, 223, 'California', 'CA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3625, 223, 'Colorado', 'CO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3626, 223, 'Connecticut', 'CT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3627, 223, 'Delaware', 'DE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3628, 223, 'District of Columbia', 'DC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3629, 223, 'Federated States Of Micronesia', 'FM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3630, 223, 'Florida', 'FL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3631, 223, 'Georgia', 'GA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3632, 223, 'Guam', 'GU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3633, 223, 'Hawaii', 'HI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3634, 223, 'Idaho', 'ID', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3635, 223, 'Illinois', 'IL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3636, 223, 'Indiana', 'IN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3637, 223, 'Iowa', 'IA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3638, 223, 'Kansas', 'KS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3639, 223, 'Kentucky', 'KY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3640, 223, 'Louisiana', 'LA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3641, 223, 'Maine', 'ME', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3642, 223, 'Marshall Islands', 'MH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3643, 223, 'Maryland', 'MD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3644, 223, 'Massachusetts', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3645, 223, 'Michigan', 'MI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3646, 223, 'Minnesota', 'MN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3647, 223, 'Mississippi', 'MS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3648, 223, 'Missouri', 'MO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3649, 223, 'Montana', 'MT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3650, 223, 'Nebraska', 'NE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3651, 223, 'Nevada', 'NV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3652, 223, 'New Hampshire', 'NH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3653, 223, 'New Jersey', 'NJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3654, 223, 'New Mexico', 'NM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3655, 223, 'New York', 'NY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3656, 223, 'North Carolina', 'NC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3657, 223, 'North Dakota', 'ND', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3658, 223, 'Northern Mariana Islands', 'MP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3659, 223, 'Ohio', 'OH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3660, 223, 'Oklahoma', 'OK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3661, 223, 'Oregon', 'OR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3662, 223, 'Palau', 'PW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3663, 223, 'Pennsylvania', 'PA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3664, 223, 'Puerto Rico', 'PR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3665, 223, 'Rhode Island', 'RI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3666, 223, 'South Carolina', 'SC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3667, 223, 'South Dakota', 'SD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3668, 223, 'Tennessee', 'TN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3669, 223, 'Texas', 'TX', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3670, 223, 'Utah', 'UT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3671, 223, 'Vermont', 'VT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3672, 223, 'Virgin Islands', 'VI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3673, 223, 'Virginia', 'VA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3674, 223, 'Washington', 'WA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3675, 223, 'West Virginia', 'WV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3676, 223, 'Wisconsin', 'WI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3677, 223, 'Wyoming', 'WY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3678, 224, 'Baker Island', 'BI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3679, 224, 'Howland Island', 'HI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3680, 224, 'Jarvis Island', 'JI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3681, 224, 'Johnston Atoll', 'JA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3682, 224, 'Kingman Reef', 'KR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3683, 224, 'Midway Atoll', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3684, 224, 'Navassa Island', 'NI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3685, 224, 'Palmyra Atoll', 'PA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3686, 224, 'Wake Island', 'WI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3687, 225, 'Artigas', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3688, 225, 'Canelones', 'CA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3689, 225, 'Cerro Largo', 'CL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3690, 225, 'Colonia', 'CO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3691, 225, 'Durazno', 'DU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3692, 225, 'Flores', 'FS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3693, 225, 'Florida', 'FA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3694, 225, 'Lavalleja', 'LA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3695, 225, 'Maldonado', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3696, 225, 'Montevideo', 'MO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3697, 225, 'Paysandu', 'PA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3698, 225, 'Rio Negro', 'RN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3699, 225, 'Rivera', 'RV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3700, 225, 'Rocha', 'RO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3701, 225, 'Salto', 'SL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3702, 225, 'San Jose', 'SJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3703, 225, 'Soriano', 'SO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3704, 225, 'Tacuarembo', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3705, 225, 'Treinta y Tres', 'TT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3706, 226, 'Andijon', 'AN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3707, 226, 'Buxoro', 'BU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3708, 226, 'Farg''ona', 'FA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3709, 226, 'Jizzax', 'JI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3710, 226, 'Namangan', 'NG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3711, 226, 'Navoiy', 'NW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3712, 226, 'Qashqadaryo', 'QA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3713, 226, 'Qoraqalpog''iston Republikasi', 'QR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3714, 226, 'Samarqand', 'SA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3715, 226, 'Sirdaryo', 'SI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3716, 226, 'Surxondaryo', 'SU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3717, 226, 'Toshkent City', 'TK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3718, 226, 'Toshkent Region', 'TO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3719, 226, 'Xorazm', 'XO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3720, 227, 'Malampa', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3721, 227, 'Penama', 'PE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3722, 227, 'Sanma', 'SA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3723, 227, 'Shefa', 'SH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3724, 227, 'Tafea', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3725, 227, 'Torba', 'TO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3726, 229, 'Amazonas', 'AM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3727, 229, 'Anzoategui', 'AN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3728, 229, 'Apure', 'AP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3729, 229, 'Aragua', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3730, 229, 'Barinas', 'BA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3731, 229, 'Bolivar', 'BO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3732, 229, 'Carabobo', 'CA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3733, 229, 'Cojedes', 'CO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3734, 229, 'Delta Amacuro', 'DA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3735, 229, 'Dependencias Federales', 'DF', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3736, 229, 'Distrito Federal', 'DI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3737, 229, 'Falcon', 'FA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3738, 229, 'Guarico', 'GU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3739, 229, 'Lara', 'LA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3740, 229, 'Merida', 'ME', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3741, 229, 'Miranda', 'MI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3742, 229, 'Monagas', 'MO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3743, 229, 'Nueva Esparta', 'NE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3744, 229, 'Portuguesa', 'PO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3745, 229, 'Sucre', 'SU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3746, 229, 'Tachira', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3747, 229, 'Trujillo', 'TR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3748, 229, 'Vargas', 'VA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3749, 229, 'Yaracuy', 'YA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3750, 229, 'Zulia', 'ZU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3751, 230, 'An Giang', 'AG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3752, 230, 'Bac Giang', 'BG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3753, 230, 'Bac Kan', 'BK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3754, 230, 'Bac Lieu', 'BL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3755, 230, 'Bac Ninh', 'BC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3756, 230, 'Ba Ria-Vung Tau', 'BR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3757, 230, 'Ben Tre', 'BN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3758, 230, 'Binh Dinh', 'BH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3759, 230, 'Binh Duong', 'BU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3760, 230, 'Binh Phuoc', 'BP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3761, 230, 'Binh Thuan', 'BT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3762, 230, 'Ca Mau', 'CM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3763, 230, 'Can Tho', 'CT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3764, 230, 'Cao Bang', 'CB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3765, 230, 'Dak Lak', 'DL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3766, 230, 'Dak Nong', 'DG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3767, 230, 'Da Nang', 'DN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3768, 230, 'Dien Bien', 'DB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3769, 230, 'Dong Nai', 'DI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3770, 230, 'Dong Thap', 'DT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3771, 230, 'Gia Lai', 'GL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3772, 230, 'Ha Giang', 'HG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3773, 230, 'Hai Duong', 'HD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3774, 230, 'Hai Phong', 'HP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3775, 230, 'Ha Nam', 'HM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3776, 230, 'Ha Noi', 'HI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3777, 230, 'Ha Tay', 'HT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3778, 230, 'Ha Tinh', 'HH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3779, 230, 'Hoa Binh', 'HB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3780, 230, 'Ho Chi Minh City', 'HC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3781, 230, 'Hau Giang', 'HU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3782, 230, 'Hung Yen', 'HY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3783, 232, 'Saint Croix', 'C', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3784, 232, 'Saint John', 'J', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3785, 232, 'Saint Thomas', 'T', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3786, 233, 'Alo', 'A', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3787, 233, 'Sigave', 'S', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3788, 233, 'Wallis', 'W', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3789, 235, 'Abyan', 'AB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3790, 235, 'Adan', 'AD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3791, 235, 'Amran', 'AM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3792, 235, 'Al Bayda', 'BA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3793, 235, 'Ad Dali', 'DA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3794, 235, 'Dhamar', 'DH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3795, 235, 'Hadramawt', 'HD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3796, 235, 'Hajjah', 'HJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3797, 235, 'Al Hudaydah', 'HU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3798, 235, 'Ibb', 'IB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3799, 235, 'Al Jawf', 'JA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3800, 235, 'Lahij', 'LA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3801, 235, 'Ma''rib', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3802, 235, 'Al Mahrah', 'MR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3803, 235, 'Al Mahwit', 'MW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3804, 235, 'Sa''dah', 'SD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3805, 235, 'San''a', 'SN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3806, 235, 'Shabwah', 'SH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3807, 235, 'Ta''izz', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3808, 236, 'Kosovo', 'KOS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3809, 236, 'Montenegro', 'MON', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3810, 236, 'Serbia', 'SER', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3811, 236, 'Vojvodina', 'VOJ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3812, 237, 'Bas-Congo', 'BC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3813, 237, 'Bandundu', 'BN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3814, 237, 'Equateur', 'EQ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3815, 237, 'Katanga', 'KA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3816, 237, 'Kasai-Oriental', 'KE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3817, 237, 'Kinshasa', 'KN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3818, 237, 'Kasai-Occidental', 'KW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3819, 237, 'Maniema', 'MA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3820, 237, 'Nord-Kivu', 'NK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3821, 237, 'Orientale', 'OR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3822, 237, 'Sud-Kivu', 'SK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3823, 238, 'Central', 'CE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3824, 238, 'Copperbelt', 'CB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3825, 238, 'Eastern', 'EA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3826, 238, 'Luapula', 'LP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3827, 238, 'Lusaka', 'LK', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3828, 238, 'Northern', 'NO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3829, 238, 'North-Western', 'NW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3830, 238, 'Southern', 'SO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3831, 238, 'Western', 'WE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3832, 239, 'Bulawayo', 'BU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3833, 239, 'Harare', 'HA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3834, 239, 'Manicaland', 'ML', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3835, 239, 'Mashonaland Central', 'MC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3836, 239, 'Mashonaland East', 'ME', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3837, 239, 'Mashonaland West', 'MW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3838, 239, 'Masvingo', 'MV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3839, 239, 'Matabeleland North', 'MN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3840, 239, 'Matabeleland South', 'MS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3841, 239, 'Midlands', 'MD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3842, 105, 'Agrigento', 'AG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3843, 105, 'Alessandria', 'AL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3844, 105, 'Ancona', 'AN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3845, 105, 'Aosta', 'AO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3846, 105, 'Arezzo', 'AR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3847, 105, 'Ascoli Piceno', 'AP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3848, 105, 'Asti', 'AT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3849, 105, 'Avellino', 'AV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3850, 105, 'Bari', 'BA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3851, 105, 'Belluno', 'BL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3852, 105, 'Benevento', 'BN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3853, 105, 'Bergamo', 'BG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3854, 105, 'Biella', 'BI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3855, 105, 'Bologna', 'BO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3856, 105, 'Bolzano', 'BZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3857, 105, 'Brescia', 'BS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3858, 105, 'Brindisi', 'BR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3859, 105, 'Cagliari', 'CA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3860, 105, 'Caltanissetta', 'CL', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3861, 105, 'Campobasso', 'CB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3862, 105, 'Carbonia-Iglesias', 'CI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3863, 105, 'Caserta', 'CE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3864, 105, 'Catania', 'CT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3865, 105, 'Catanzaro', 'CZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3866, 105, 'Chieti', 'CH', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3867, 105, 'Como', 'CO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3868, 105, 'Cosenza', 'CS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3869, 105, 'Cremona', 'CR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3870, 105, 'Crotone', 'KR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3871, 105, 'Cuneo', 'CN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3872, 105, 'Enna', 'EN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3873, 105, 'Ferrara', 'FE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3874, 105, 'Firenze', 'FI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3875, 105, 'Foggia', 'FG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3876, 105, 'Forli-Cesena', 'FC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3877, 105, 'Frosinone', 'FR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3878, 105, 'Genova', 'GE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3879, 105, 'Gorizia', 'GO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3880, 105, 'Grosseto', 'GR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3881, 105, 'Imperia', 'IM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3882, 105, 'Isernia', 'IS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3883, 105, 'L&#39;Aquila', 'AQ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3884, 105, 'La Spezia', 'SP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3885, 105, 'Latina', 'LT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3886, 105, 'Lecce', 'LE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3887, 105, 'Lecco', 'LC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3888, 105, 'Livorno', 'LI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3889, 105, 'Lodi', 'LO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3890, 105, 'Lucca', 'LU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3891, 105, 'Macerata', 'MC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3892, 105, 'Mantova', 'MN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3893, 105, 'Massa-Carrara', 'MS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3894, 105, 'Matera', 'MT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3895, 105, 'Medio Campidano', 'VS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3896, 105, 'Messina', 'ME', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3897, 105, 'Milano', 'MI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3898, 105, 'Modena', 'MO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3899, 105, 'Napoli', 'NA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3900, 105, 'Novara', 'NO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3901, 105, 'Nuoro', 'NU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3902, 105, 'Ogliastra', 'OG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3903, 105, 'Olbia-Tempio', 'OT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3904, 105, 'Oristano', 'OR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3905, 105, 'Padova', 'PD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3906, 105, 'Palermo', 'PA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3907, 105, 'Parma', 'PR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3908, 105, 'Pavia', 'PV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3909, 105, 'Perugia', 'PG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3910, 105, 'Pesaro e Urbino', 'PU', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3911, 105, 'Pescara', 'PE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3912, 105, 'Piacenza', 'PC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3913, 105, 'Pisa', 'PI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3914, 105, 'Pistoia', 'PT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3915, 105, 'Pordenone', 'PN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3916, 105, 'Potenza', 'PZ', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3917, 105, 'Prato', 'PO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3918, 105, 'Ragusa', 'RG', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3919, 105, 'Ravenna', 'RA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3920, 105, 'Reggio Calabria', 'RC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3921, 105, 'Reggio Emilia', 'RE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3922, 105, 'Rieti', 'RI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3923, 105, 'Rimini', 'RN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3924, 105, 'Roma', 'RM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3925, 105, 'Rovigo', 'RO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3926, 105, 'Salerno', 'SA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3927, 105, 'Sassari', 'SS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3928, 105, 'Savona', 'SV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3929, 105, 'Siena', 'SI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3930, 105, 'Siracusa', 'SR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3931, 105, 'Sondrio', 'SO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3932, 105, 'Taranto', 'TA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3933, 105, 'Teramo', 'TE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3934, 105, 'Terni', 'TR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3935, 105, 'Torino', 'TO', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3936, 105, 'Trapani', 'TP', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3937, 105, 'Trento', 'TN', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3938, 105, 'Treviso', 'TV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3939, 105, 'Trieste', 'TS', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3940, 105, 'Udine', 'UD', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3941, 105, 'Varese', 'VA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3942, 105, 'Venezia', 'VE', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3943, 105, 'Verbano-Cusio-Ossola', 'VB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3944, 105, 'Vercelli', 'VC', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3945, 105, 'Verona', 'VR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3946, 105, 'Vibo Valentia', 'VV', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3947, 105, 'Vicenza', 'VI', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3948, 105, 'Viterbo', 'VT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3949, 222, 'County Antrim', 'ANT', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3950, 222, 'County Armagh', 'ARM', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3951, 222, 'County Down', 'DOW', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3952, 222, 'County Fermanagh', 'FER', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3953, 222, 'County Londonderry', 'LDY', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3954, 222, 'County Tyrone', 'TYR', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3955, 222, 'Cumbria', 'CMA', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3956, 190, 'Pomurska', '1', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3957, 190, 'Podravska', '2', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3958, 190, 'Koroška', '3', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3959, 190, 'Savinjska', '4', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3960, 190, 'Zasavska', '5', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3961, 190, 'Spodnjeposavska', '6', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3962, 190, 'Jugovzhodna Slovenija', '7', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3963, 190, 'Osrednjeslovenska', '8', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3964, 190, 'Gorenjska', '9', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3965, 190, 'Notranjsko-kraška', '10', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3966, 190, 'Goriška', '11', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3967, 190, 'Obalno-kraška', '12', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3968, 33, 'Ruse', '', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24'),
(3969, 101, 'Alborz', 'ALB', 'active', '2013-06-07 21:18:24', '2013-06-07 21:18:24');

--
-- Ограничения внешнего ключа сохраненных таблиц
--

--
-- Ограничения внешнего ключа таблицы `mw_article_category`
--
ALTER TABLE `mw_article_category`
  ADD CONSTRAINT `fk_article_category_article_category1` FOREIGN KEY (`parent_id`) REFERENCES `mw_article_category` (`category_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_article_to_category`
--
ALTER TABLE `mw_article_to_category`
  ADD CONSTRAINT `fk_article_to_category_article1` FOREIGN KEY (`article_id`) REFERENCES `mw_article` (`article_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_article_to_category_article_category1` FOREIGN KEY (`category_id`) REFERENCES `mw_article_category` (`category_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_bounce_server`
--
ALTER TABLE `mw_bounce_server`
  ADD CONSTRAINT `fk_bounce_server_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign`
--
ALTER TABLE `mw_campaign`
  ADD CONSTRAINT `fk_campaign_campaign_group1` FOREIGN KEY (`group_id`) REFERENCES `mw_campaign_group` (`group_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_list_segment1` FOREIGN KEY (`segment_id`) REFERENCES `mw_list_segment` (`segment_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_abuse_report`
--
ALTER TABLE `mw_campaign_abuse_report`
  ADD CONSTRAINT `fk_campaign_abuse_report_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_abuse_report_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_abuse_report_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_abuse_report_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_attachment`
--
ALTER TABLE `mw_campaign_attachment`
  ADD CONSTRAINT `fk_campaign_attachment_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_bounce_log`
--
ALTER TABLE `mw_campaign_bounce_log`
  ADD CONSTRAINT `fk_campaign_bounce_log_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_bounce_log_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_delivery_log`
--
ALTER TABLE `mw_campaign_delivery_log`
  ADD CONSTRAINT `fk_campaign_delivery_log_delivery_server1` FOREIGN KEY (`server_id`) REFERENCES `mw_delivery_server` (`server_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_delivery_log_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_delivery_log_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_delivery_log_archive`
--
ALTER TABLE `mw_campaign_delivery_log_archive`
  ADD CONSTRAINT `fk_campaign_delivery_log_archive_delivery_server1` FOREIGN KEY (`server_id`) REFERENCES `mw_delivery_server` (`server_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_delivery_log_archive_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_delivery_log_archive_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_forward_friend`
--
ALTER TABLE `mw_campaign_forward_friend`
  ADD CONSTRAINT `fk_campaign_forward_friend_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_forward_friend_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_group`
--
ALTER TABLE `mw_campaign_group`
  ADD CONSTRAINT `fk_campaign_group_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_open_action_list_field`
--
ALTER TABLE `mw_campaign_open_action_list_field`
  ADD CONSTRAINT `fk_campaign_open_action_list_field_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_open_action_list_field_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_open_action_list_field_list_field1` FOREIGN KEY (`field_id`) REFERENCES `mw_list_field` (`field_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_open_action_subscriber`
--
ALTER TABLE `mw_campaign_open_action_subscriber`
  ADD CONSTRAINT `fk_campaign_open_action_subscriber_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_open_action_subscriber_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_option`
--
ALTER TABLE `mw_campaign_option`
  ADD CONSTRAINT `fk_campaign_option_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_option_campaign2` FOREIGN KEY (`autoresponder_open_campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_option_campaign3` FOREIGN KEY (`regular_open_unopen_campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_option_campaign4` FOREIGN KEY (`tracking_domain_id`) REFERENCES `mw_tracking_domain` (`domain_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_template`
--
ALTER TABLE `mw_campaign_template`
  ADD CONSTRAINT `fk_campaign_template_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_customer_email_template1` FOREIGN KEY (`customer_template_id`) REFERENCES `mw_customer_email_template` (`template_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_template_url_action_list_field`
--
ALTER TABLE `mw_campaign_template_url_action_list_field`
  ADD CONSTRAINT `fk_campaign_template_url_action_list_field_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_template_url_action_list_field_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_template_url_action_list_field_campaign_templa1` FOREIGN KEY (`template_id`) REFERENCES `mw_campaign_template` (`template_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_template_url_action_list_field_list_field1` FOREIGN KEY (`field_id`) REFERENCES `mw_list_field` (`field_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_template_url_action_subscriber`
--
ALTER TABLE `mw_campaign_template_url_action_subscriber`
  ADD CONSTRAINT `fk_campaign_template_url_action_subscriber_campaign_tem1` FOREIGN KEY (`template_id`) REFERENCES `mw_campaign_template` (`template_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_template_url_action_subscriber_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_template_url_action_subscriber_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_temporary_source`
--
ALTER TABLE `mw_campaign_temporary_source`
  ADD CONSTRAINT `fk_campaign_temporary_source_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_temporary_source_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_temporary_source_list_segment1` FOREIGN KEY (`segment_id`) REFERENCES `mw_list_segment` (`segment_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_to_delivery_server`
--
ALTER TABLE `mw_campaign_to_delivery_server`
  ADD CONSTRAINT `fk_campaign_to_delivery_server_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_to_delivery_server_delivery_server1` FOREIGN KEY (`server_id`) REFERENCES `mw_delivery_server` (`server_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_track_open`
--
ALTER TABLE `mw_campaign_track_open`
  ADD CONSTRAINT `fk_campaign_track_open_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_track_open_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_track_open_ip_location1` FOREIGN KEY (`location_id`) REFERENCES `mw_ip_location` (`location_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_track_unsubscribe`
--
ALTER TABLE `mw_campaign_track_unsubscribe`
  ADD CONSTRAINT `fk_campaign_track_unsubscribe_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_track_unsubscribe_ip_location1` FOREIGN KEY (`location_id`) REFERENCES `mw_ip_location` (`location_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_track_unsubscribe_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_track_url`
--
ALTER TABLE `mw_campaign_track_url`
  ADD CONSTRAINT `fk_campaign_track_url_campaign_url1` FOREIGN KEY (`url_id`) REFERENCES `mw_campaign_url` (`url_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_track_url_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_campaign_track_url_ip_location1` FOREIGN KEY (`location_id`) REFERENCES `mw_ip_location` (`location_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_campaign_url`
--
ALTER TABLE `mw_campaign_url`
  ADD CONSTRAINT `fk_campaign_url_campaign1` FOREIGN KEY (`campaign_id`) REFERENCES `mw_campaign` (`campaign_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_customer`
--
ALTER TABLE `mw_customer`
  ADD CONSTRAINT `fk_customer_customer_group1` FOREIGN KEY (`group_id`) REFERENCES `mw_customer_group` (`group_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_customer_language1` FOREIGN KEY (`language_id`) REFERENCES `mw_language` (`language_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_customer_action_log`
--
ALTER TABLE `mw_customer_action_log`
  ADD CONSTRAINT `fk_customer_notification_log_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_customer_api_key`
--
ALTER TABLE `mw_customer_api_key`
  ADD CONSTRAINT `fk_customer_api_key_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_customer_auto_login_token`
--
ALTER TABLE `mw_customer_auto_login_token`
  ADD CONSTRAINT `fk_customer_auto_login_token_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_customer_campaign_tag`
--
ALTER TABLE `mw_customer_campaign_tag`
  ADD CONSTRAINT `fk_customer_campaign_tag_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_customer_company`
--
ALTER TABLE `mw_customer_company`
  ADD CONSTRAINT `fk_customer_company_company_type1` FOREIGN KEY (`type_id`) REFERENCES `mw_company_type` (`type_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_customer_company_country10` FOREIGN KEY (`country_id`) REFERENCES `mw_country` (`country_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_customer_company_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_customer_company_zone10` FOREIGN KEY (`zone_id`) REFERENCES `mw_zone` (`zone_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_customer_email_blacklist`
--
ALTER TABLE `mw_customer_email_blacklist`
  ADD CONSTRAINT `fk_customer_email_blacklist_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_customer_email_template`
--
ALTER TABLE `mw_customer_email_template`
  ADD CONSTRAINT `fk_customer_email_template_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_customer_group_option`
--
ALTER TABLE `mw_customer_group_option`
  ADD CONSTRAINT `fk_customer_group_option_customer_group1` FOREIGN KEY (`group_id`) REFERENCES `mw_customer_group` (`group_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_customer_login_log`
--
ALTER TABLE `mw_customer_login_log`
  ADD CONSTRAINT `fk_customer_login_log_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_customer_login_log_ip_location1` FOREIGN KEY (`location_id`) REFERENCES `mw_ip_location` (`location_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_customer_message`
--
ALTER TABLE `mw_customer_message`
  ADD CONSTRAINT `fk_customer_message_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_customer_password_reset`
--
ALTER TABLE `mw_customer_password_reset`
  ADD CONSTRAINT `fk_customer_password_reset_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_customer_quota_mark`
--
ALTER TABLE `mw_customer_quota_mark`
  ADD CONSTRAINT `fk_customer_quota_mark_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_delivery_server`
--
ALTER TABLE `mw_delivery_server`
  ADD CONSTRAINT `fk_delivery_server1` FOREIGN KEY (`bounce_server_id`) REFERENCES `mw_bounce_server` (`server_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_delivery_server_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_delivery_server_tracking_domain1` FOREIGN KEY (`tracking_domain_id`) REFERENCES `mw_tracking_domain` (`domain_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_delivery_server_domain_policy`
--
ALTER TABLE `mw_delivery_server_domain_policy`
  ADD CONSTRAINT `fk_delivery_server_domain_policy_delivery_server1` FOREIGN KEY (`server_id`) REFERENCES `mw_delivery_server` (`server_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_delivery_server_to_customer_group`
--
ALTER TABLE `mw_delivery_server_to_customer_group`
  ADD CONSTRAINT `fk_delivery_server_to_customer_group_delivery_server1` FOREIGN KEY (`server_id`) REFERENCES `mw_delivery_server` (`server_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_delivery_server_to_customer_group_customer_group1` FOREIGN KEY (`group_id`) REFERENCES `mw_customer_group` (`group_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_delivery_server_usage_log`
--
ALTER TABLE `mw_delivery_server_usage_log`
  ADD CONSTRAINT `fk_delivery_server_usage_log_delivery_server1` FOREIGN KEY (`server_id`) REFERENCES `mw_delivery_server` (`server_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_delivery_server_usage_log_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_email_blacklist`
--
ALTER TABLE `mw_email_blacklist`
  ADD CONSTRAINT `fk_email_blacklist1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_feedback_loop_server`
--
ALTER TABLE `mw_feedback_loop_server`
  ADD CONSTRAINT `fk_feedback_loop_server_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_list`
--
ALTER TABLE `mw_list`
  ADD CONSTRAINT `fk_list_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_list_company`
--
ALTER TABLE `mw_list_company`
  ADD CONSTRAINT `fk_customer_company_country100` FOREIGN KEY (`country_id`) REFERENCES `mw_country` (`country_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_customer_company_zone100` FOREIGN KEY (`zone_id`) REFERENCES `mw_zone` (`zone_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_list_company_company_type1` FOREIGN KEY (`type_id`) REFERENCES `mw_company_type` (`type_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_list_company_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_list_customer_notification`
--
ALTER TABLE `mw_list_customer_notification`
  ADD CONSTRAINT `fk_list_notification_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_list_default`
--
ALTER TABLE `mw_list_default`
  ADD CONSTRAINT `fk_list_default_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_list_field`
--
ALTER TABLE `mw_list_field`
  ADD CONSTRAINT `fk_list_field_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_list_field_list_field_type1` FOREIGN KEY (`type_id`) REFERENCES `mw_list_field_type` (`type_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_list_field_option`
--
ALTER TABLE `mw_list_field_option`
  ADD CONSTRAINT `fk_list_field_option_list_field1` FOREIGN KEY (`field_id`) REFERENCES `mw_list_field` (`field_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_list_field_value`
--
ALTER TABLE `mw_list_field_value`
  ADD CONSTRAINT `fk_list_field_value_list_field1` FOREIGN KEY (`field_id`) REFERENCES `mw_list_field` (`field_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_list_field_value_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_list_page`
--
ALTER TABLE `mw_list_page`
  ADD CONSTRAINT `fk_list_page_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_list_page_list_page_type1` FOREIGN KEY (`type_id`) REFERENCES `mw_list_page_type` (`type_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_list_segment`
--
ALTER TABLE `mw_list_segment`
  ADD CONSTRAINT `fk_list_segment_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_list_segment_condition`
--
ALTER TABLE `mw_list_segment_condition`
  ADD CONSTRAINT `fk_list_segment_condition_list_field1` FOREIGN KEY (`field_id`) REFERENCES `mw_list_field` (`field_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_list_segment_condition_list_segment1` FOREIGN KEY (`segment_id`) REFERENCES `mw_list_segment` (`segment_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_list_segment_condition_list_segment_operator1` FOREIGN KEY (`operator_id`) REFERENCES `mw_list_segment_operator` (`operator_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_list_subscriber`
--
ALTER TABLE `mw_list_subscriber`
  ADD CONSTRAINT `fk_subscriber_list1` FOREIGN KEY (`list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_list_subscriber_action`
--
ALTER TABLE `mw_list_subscriber_action`
  ADD CONSTRAINT `fk_list_subscriber_action_list1` FOREIGN KEY (`source_list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_list_subscriber_action_list2` FOREIGN KEY (`target_list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_list_subscriber_field_cache`
--
ALTER TABLE `mw_list_subscriber_field_cache`
  ADD CONSTRAINT `fk_list_subscriber_field_cache_list_subscriber1` FOREIGN KEY (`subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_list_subscriber_list_move`
--
ALTER TABLE `mw_list_subscriber_list_move`
  ADD CONSTRAINT `fk_list_subscriber_list_move_list_subscriber1` FOREIGN KEY (`source_subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_list_subscriber_list_move_list1` FOREIGN KEY (`source_list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_list_subscriber_list_move_list_subscriber2` FOREIGN KEY (`destination_subscriber_id`) REFERENCES `mw_list_subscriber` (`subscriber_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_list_subscriber_list_move_list2` FOREIGN KEY (`destination_list_id`) REFERENCES `mw_list` (`list_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_price_plan`
--
ALTER TABLE `mw_price_plan`
  ADD CONSTRAINT `fk_price_plan_customer_group1` FOREIGN KEY (`group_id`) REFERENCES `mw_customer_group` (`group_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_price_plan_order`
--
ALTER TABLE `mw_price_plan_order`
  ADD CONSTRAINT `fk_price_plan_order_price_plan1` FOREIGN KEY (`plan_id`) REFERENCES `mw_price_plan` (`plan_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_price_plan_order_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_price_plan_order_price_plan_promo_code1` FOREIGN KEY (`promo_code_id`) REFERENCES `mw_price_plan_promo_code` (`promo_code_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_price_plan_order_currency1` FOREIGN KEY (`currency_id`) REFERENCES `mw_currency` (`currency_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_price_plan_order_tax1` FOREIGN KEY (`tax_id`) REFERENCES `mw_tax` (`tax_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_price_plan_order_note`
--
ALTER TABLE `mw_price_plan_order_note`
  ADD CONSTRAINT `fk_price_plan_order_note_price_plan_order1` FOREIGN KEY (`order_id`) REFERENCES `mw_price_plan_order` (`order_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_price_plan_order_note_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_price_plan_order_note_user1` FOREIGN KEY (`user_id`) REFERENCES `mw_user` (`user_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_price_plan_order_transaction`
--
ALTER TABLE `mw_price_plan_order_transaction`
  ADD CONSTRAINT `fk_price_plan_order_transaction_price_plan_order1` FOREIGN KEY (`order_id`) REFERENCES `mw_price_plan_order` (`order_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_sending_domain`
--
ALTER TABLE `mw_sending_domain`
  ADD CONSTRAINT `fk_sending_domain_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_tax`
--
ALTER TABLE `mw_tax`
  ADD CONSTRAINT `fk_tax_country1` FOREIGN KEY (`country_id`) REFERENCES `mw_country` (`country_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_tax_zone1` FOREIGN KEY (`zone_id`) REFERENCES `mw_zone` (`zone_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_tracking_domain`
--
ALTER TABLE `mw_tracking_domain`
  ADD CONSTRAINT `fk_tracking_domain_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_transactional_email`
--
ALTER TABLE `mw_transactional_email`
  ADD CONSTRAINT `fk_transactional_email_customer1` FOREIGN KEY (`customer_id`) REFERENCES `mw_customer` (`customer_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_transactional_email_log`
--
ALTER TABLE `mw_transactional_email_log`
  ADD CONSTRAINT `fk_transactional_email_log_transactional_email1` FOREIGN KEY (`email_id`) REFERENCES `mw_transactional_email` (`email_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_user`
--
ALTER TABLE `mw_user`
  ADD CONSTRAINT `fk_user_user_group1` FOREIGN KEY (`group_id`) REFERENCES `mw_user_group` (`group_id`) ON DELETE SET NULL ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_user_language1` FOREIGN KEY (`language_id`) REFERENCES `mw_language` (`language_id`) ON DELETE SET NULL ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_user_auto_login_token`
--
ALTER TABLE `mw_user_auto_login_token`
  ADD CONSTRAINT `fk_user_auto_login_token_user1` FOREIGN KEY (`user_id`) REFERENCES `mw_user` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_user_group_route_access`
--
ALTER TABLE `mw_user_group_route_access`
  ADD CONSTRAINT `fk_user_group_route_access_user_group1` FOREIGN KEY (`group_id`) REFERENCES `mw_user_group` (`group_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_user_password_reset`
--
ALTER TABLE `mw_user_password_reset`
  ADD CONSTRAINT `fk_user_password_reset_user1` FOREIGN KEY (`user_id`) REFERENCES `mw_user` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Ограничения внешнего ключа таблицы `mw_zone`
--
ALTER TABLE `mw_zone`
  ADD CONSTRAINT `fk_zone_country1` FOREIGN KEY (`country_id`) REFERENCES `mw_country` (`country_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

